import mysql.connector

conn = mysql.connector.connect(user='root', password='Pass@word',
                               host='localhost', port='3306',
                               database='python', use_unicode=True)
c = conn.cursor()
c.execute('insert into user_tb values (null ,%s, %s,%s)', ('wk', '123', 'male'))
c.execute('insert into order_tb values (null ,%s,%s,%s,%s)', ('mouse', '34', '3', 4))
conn.commit()
c.close()
conn.close()
